Dashboard 02 - Creating Map, & Line and Clustered Column charts Visualizations 16

In this step, we will create a map and charts in the 2nd dashboard / page.


Step 1 - Average Violent Crimes Per Day by Group Line and Clustered Column chart



Visualizations

Click the Line and Clustered Column chart icon

Fields

Select the following:

A_KeyMeasures ->  .AVG_Violent_Crimes_PerDay  - Under Visualizations, drag & drop it in the Column Values section.

A_KeyMeasures ->  .YOY_Violent_Crimes%  - Under Visualizations, drag & drop it in the Line Values section.

Raleigh_Police_Incidents_NIBRS ->  Crime_Category - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  Crime_Description - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  reported_dayofwk - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  reported_hour - Under Visualizations, drag & drop it in the Shared Axis section



Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.AVG_Violent_Crimes_PerDay = Avg Violent Crimes/Day

.YOY_Violent_Crimes%  = YOY Violent Crimes

Crime_Category = Crime Category

Crime_Description = Crime Description

reported_dayofwk = Reported Day of the Week

reported_hour = Reported Hour





Visualization Listing

For Line and Clustered Column chart, have the visualizations listed in the following order:




Visualizations

Format tab

Similar to the previously created Line and Clustered Column charts, set up the format:


Under Format ->  General: X Position = 225 , Y Position = 144 , Width = 539 , Height = 437

Under Format -> Legend ->  Set it to ON , Position = Top Center , Color = 000000 , Font Family = Segoe UI , Text Size = 11 pt , Style = Markers Only

Under Format -> X Axis -> Color = 000000 , Text Size = 10 pt , Font Family = Segoe UI , Title = OFF

Under Format -> Y Axis -> Position = Left , Scale Type = Linear ->  Color = 000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Style = Show Title OFF , Gridlines = ON , Color = 000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF

Under Format ->  Data Colors -> YOY Violent Crimes = 6B007B , Default Color = CF6B7D

Under Format ->  Data Labels ->  Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 13 pt , Font Family = Segoe UI , Show Background = Off ,

Customize Series  = ON ,

(Select Average Violent Crimes Per Day ->  Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,

(Select YOY Violent Crimes ->  Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,

Under Format ->  Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5

Under Format -> Title ->  Set it to ON , Title Text = Average Violent Crimes Per Day by Group , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666




Summary:



Filters

None


Step 2 - Create Top Average Major Crimes Per Day by Group Line and Clustered Column chart


To get you started, use the previous chart as a template.  Click on the Average Violent Crimes Per Day by Group Line and Clustered Column chart, press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied chart, set up as follows:


Visualizations

Fields

Select the following:

A_KeyMeasures ->  .AVG_Major_Crimes_PerDay  - Under Visualizations, drag & drop it in the Column Values section.

A_KeyMeasures ->  .YOY_Major_Crimes%  - Under Visualizations, drag & drop it in the Line Values section.

Raleigh_Police_Incidents_NIBRS ->  Crime_Category - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  Crime_Description - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  reported_dayofwk - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  reported_hour - Under Visualizations, drag & drop it in the Shared Axis section



Visualization Listing

For Line and Clustered Column chart, have the visualizations listed in the following order:





Visualizations

Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.AVG_Major_Crimes_PerDay = Avg Major Crimes Per Day

.YOY_Major_Crimes%  = YOY Major Crimes

Crime_Category = Crime Category

Crime_Description = Crime Description

reported_dayofwk = Reported Day of the Week

reported_hour = Reported Hour




Format tab


Similar to the previously created Line and Clustered Column charts, set up the format:

Under Format ->  General: X Position = 225 , Y Position = 581 , Width = 1175 , Height = 365

Under Format -> Legend ->  Set it to ON , Position = Top Center , Color = 000000 , Font Family = Segoe UI , Text Size = 11 pt , Style = Markers Only

Under Format -> X Axis -> Color = 000000 , Text Size = 10 pt , Font Family = Segoe UI , Title = OFF

Under Format -> Y Axis -> Position = Left , Scale Type = Linear ->  Color = 000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Style = Show Title OFF , Gridlines = ON , Color = 000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF

Under Format ->  Data Colors -> YOY Major Crimes = 0D6ABF, Default Color = 70BBFF

Under Format ->  Data Labels ->  Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 13 pt , Font Family = Segoe UI , Show Background = Off ,

Customize Series  = ON ,

(Select Average Major Crimes Per Day ->  Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,

(Select YOY Major Crimes ->  Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Show Background = OFF) ,

Under Format ->  Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5

Under Format -> Title ->  Set it to ON , Title Text = Top Average Major Crimes Per Day by Group , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666



Summary:




Step 3 - Add filter(s)


Filters

Under Filters ->  Crime Category ->  Filter Type = Top N -> Show items = Top and enter 20 , By Value = A_KeyMeasures ->  .AVG_Major_Crimes_PerDay



Step 4 -


Sorting

Sort by Reported Day of the week.





When finished, save project.


Creating a Line and Clustered Column Chart in Power BI

Tips and Tricks for Maps in Power BI